prepare("select * from news ORDER BY newsdate DESC"); $stmt->execute(); ?> rowCount() > 0) { while($row=$stmt->FETCH(PDO::FETCH_ASSOC)) { $id = $row['sn'] ; $newsevent = $row['content'] ; echo $newsevent ; echo '
' ; echo '
' ; echo '-----Next-----' ; echo '
' ; echo '
' ; } } ?>

DOWNLOAD ASSIGNMENT